if exists(select name from sysobjects where name = 'sp_LoaiKhuyenMaiGetInfoByTieude')
	drop proc sp_LoaiKhuyenMaiGetInfoByTieude
go
/*-- =============================================
	Created by: HP
	Created on: 2014-06-18 (dd/mm/yyyy)
	Description: 
	--

	File:$sql-scripts/Proc.sp_LoaiKhuyenMaiGetInfoByTieude.sql
*/-- =============================================

CREATE PROCEDURE sp_LoaiKhuyenMaiGetInfoByTieude
			
	@TieuDe		Nvarchar(512)
AS
BEGIN	
	SELECT
		a.[LoaiKhuyenMaiId],
		a.[TenLoaiKhuyenMai],
		a.[LoaiKhuyenMaiChaId],
		a.[TrangThai],
		a.Title,
		a.KeyWords,
		a.Description
	FROM
		LoaiKhuyenMai a
	WHERE
		    a.TenLoaiKhuyenMaiId = @TieuDe;
END
GO

